YData Profiling Report

Dataset statistics

Number of variables	14
Number of observations	1000000
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	50009
Duplicate rows (%)	5.0%
Total size in memory	491.5 MiB
Average record size in memory	515.4 B

Variable types

Categorical	4
Text	1
DateTime	2
Numeric	7

Alerts

Dataset has 50009 (5.0%) duplicate rows	Duplicates
`Item Type` is highly overall correlated with `Unit Cost` and 1 other fields	High correlation
`Total Cost` is highly overall correlated with `Total Profit` and 4 other fields	High correlation
`Total Profit` is highly overall correlated with `Total Cost` and 4 other fields	High correlation
`Total Revenue` is highly overall correlated with `Total Cost` and 4 other fields	High correlation
`Unit Cost` is highly overall correlated with `Item Type` and 4 other fields	High correlation
`Unit Price` is highly overall correlated with `Item Type` and 4 other fields	High correlation
`Units Sold` is highly overall correlated with `Total Cost` and 2 other fields	High correlation

Reproduction

Analysis started	2025-03-16 08:53:33.808812
Analysis finished	2025-03-16 08:55:03.202577
Duration	1 minute and 29.39 seconds
Software version	ydata-profiling vv4.14.0
Download configuration	config.json

Region
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	69.5 MiB

Sub-Saharan Africa	259953
Europe	259036
Asia	146017
Middle East and North Africa	124344
Central America and the Caribbean	108042
Other values (2)	102608

Length

Max length	33
Median length	28
Mean length	15.845056
Min length	4

Characters and Unicode

Total characters	15845056
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sub-Saharan Africa
2nd row	Middle East and North Africa
3rd row	Australia and Oceania
4th row	Sub-Saharan Africa
5th row	Europe

Common Values

Value	Count	Frequency (%)
Sub-Saharan Africa	259953	26.0%
Europe	259036	25.9%
Asia	146017	14.6%
Middle East and North Africa	124344	12.4%
Central America and the Caribbean	108042	10.8%
Australia and Oceania	80837	8.1%
North America	21771	2.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
africa	384297	16.2%
and	313223	13.2%
sub-saharan	259953	11.0%
europe	259036	10.9%
north	146115	6.2%
asia	146017	6.2%
america	129813	5.5%
middle	124344	5.2%
east	124344	5.2%
central	108042	4.6%
Other values (4)	377758	15.9%

Most occurring characters

Value	Count	Frequency (%)
a	2525027	15.9%
r	1476135	9.3%
	1372942	8.7%
i	1054187	6.7%
e	918156	5.8%
n	870097	5.5%
A	740964	4.7%
u	599826	3.8%
c	594947	3.8%
t	567380	3.6%
Other values (16)	5125395	32.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	15845056	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	2525027	15.9%
r	1476135	9.3%
	1372942	8.7%
i	1054187	6.7%
e	918156	5.8%
n	870097	5.5%
A	740964	4.7%
u	599826	3.8%
c	594947	3.8%
t	567380	3.6%
Other values (16)	5125395	32.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	15845056	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	2525027	15.9%
r	1476135	9.3%
	1372942	8.7%
i	1054187	6.7%
e	918156	5.8%
n	870097	5.5%
A	740964	4.7%
u	599826	3.8%
c	594947	3.8%
t	567380	3.6%
Other values (16)	5125395	32.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	15845056	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	2525027	15.9%
r	1476135	9.3%
	1372942	8.7%
i	1054187	6.7%
e	918156	5.8%
n	870097	5.5%
A	740964	4.7%
u	599826	3.8%
c	594947	3.8%
t	567380	3.6%
Other values (16)	5125395	32.3%

Country
Text

Distinct	185
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.9 MiB

Length

Max length	32
Median length	22
Mean length	8.90437
Min length	4

Characters and Unicode

Total characters	8904370
Distinct characters	53
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	South Africa
2nd row	Morocco
3rd row	Papua New Guinea
4th row	Djibouti
5th row	Slovakia

Value	Count	Frequency (%)
and	32435	2.4%
republic	27164	2.1%
the	27042	2.0%
of	21727	1.6%
saint	16247	1.2%
guinea	16235	1.2%
south	16216	1.2%
united	16202	1.2%
states	10901	0.8%
new	10893	0.8%
Other values (205)	1129873	85.3%

Most occurring characters

Value	Count	Frequency (%)
a	1346140	15.1%
i	773466	8.7%
n	702943	7.9%
e	622961	7.0%
o	486201	5.5%
r	470532	5.3%
t	367724	4.1%
	362809	4.1%
u	312437	3.5%
l	292114	3.3%
Other values (43)	3167043	35.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8904370	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	1346140	15.1%
i	773466	8.7%
n	702943	7.9%
e	622961	7.0%
o	486201	5.5%
r	470532	5.3%
t	367724	4.1%
	362809	4.1%
u	312437	3.5%
l	292114	3.3%
Other values (43)	3167043	35.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8904370	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	1346140	15.1%
i	773466	8.7%
n	702943	7.9%
e	622961	7.0%
o	486201	5.5%
r	470532	5.3%
t	367724	4.1%
	362809	4.1%
u	312437	3.5%
l	292114	3.3%
Other values (43)	3167043	35.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8904370	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	1346140	15.1%
i	773466	8.7%
n	702943	7.9%
e	622961	7.0%
o	486201	5.5%
r	470532	5.3%
t	367724	4.1%
	362809	4.1%
u	312437	3.5%
l	292114	3.3%
Other values (43)	3167043	35.6%

Item Type
Categorical

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	62.5 MiB

Fruits	83551
Personal Care	83539
Snacks	83448
Cosmetics	83431
Baby Food	83397
Other values (7)	582634

Length

Max length	15
Median length	13
Mean length	8.583558
Min length	4

Characters and Unicode

Total characters	8583558
Distinct characters	31
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fruits
2nd row	Clothes
3rd row	Meat
4th row	Clothes
5th row	Beverages

Common Values

Value	Count	Frequency (%)
Fruits	83551	8.4%
Personal Care	83539	8.4%
Snacks	83448	8.3%
Cosmetics	83431	8.3%
Baby Food	83397	8.3%
Beverages	83326	8.3%
Household	83267	8.3%
Clothes	83240	8.3%
Office Supplies	83222	8.3%
Cereal	83211	8.3%
Other values (2)	166368	16.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fruits	83551	6.7%
personal	83539	6.7%
care	83539	6.7%
snacks	83448	6.7%
cosmetics	83431	6.7%
baby	83397	6.7%
food	83397	6.7%
beverages	83326	6.7%
household	83267	6.7%
clothes	83240	6.7%
Other values (5)	416023	33.3%

Most occurring characters

Value	Count	Frequency (%)
e	1332568	15.5%
s	833625	9.7%
a	666828	7.8%
o	583538	6.8%
l	499649	5.8%
r	417166	4.9%
t	416590	4.9%
i	333426	3.9%
C	333421	3.9%
	250158	2.9%
Other values (21)	2916589	34.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	8583558	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
e	1332568	15.5%
s	833625	9.7%
a	666828	7.8%
o	583538	6.8%
l	499649	5.8%
r	417166	4.9%
t	416590	4.9%
i	333426	3.9%
C	333421	3.9%
	250158	2.9%
Other values (21)	2916589	34.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	8583558	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
e	1332568	15.5%
s	833625	9.7%
a	666828	7.8%
o	583538	6.8%
l	499649	5.8%
r	417166	4.9%
t	416590	4.9%
i	333426	3.9%
C	333421	3.9%
	250158	2.9%
Other values (21)	2916589	34.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	8583558	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
e	1332568	15.5%
s	833625	9.7%
a	666828	7.8%
o	583538	6.8%
l	499649	5.8%
r	417166	4.9%
t	416590	4.9%
i	333426	3.9%
C	333421	3.9%
	250158	2.9%
Other values (21)	2916589	34.0%

Sales Channel
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	60.6 MiB

Offline	500249
Online	499751

Length

Max length	7
Median length	7
Mean length	6.500249
Min length	6

Characters and Unicode

Total characters	6500249
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Offline
2nd row	Online
3rd row	Offline
4th row	Offline
5th row	Offline

Common Values

Value	Count	Frequency (%)
Offline	500249	50.0%
Online	499751	50.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
offline	500249	50.0%
online	499751	50.0%

Most occurring characters

Value	Count	Frequency (%)
n	1499751	23.1%
f	1000498	15.4%
O	1000000	15.4%
l	1000000	15.4%
i	1000000	15.4%
e	1000000	15.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6500249	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
n	1499751	23.1%
f	1000498	15.4%
O	1000000	15.4%
l	1000000	15.4%
i	1000000	15.4%
e	1000000	15.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6500249	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
n	1499751	23.1%
f	1000498	15.4%
O	1000000	15.4%
l	1000000	15.4%
i	1000000	15.4%
e	1000000	15.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6500249	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
n	1499751	23.1%
f	1000498	15.4%
O	1000000	15.4%
l	1000000	15.4%
i	1000000	15.4%
e	1000000	15.4%

Order Priority
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.3 MiB

C	250313
L	250133
H	249861
M	249693

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1000000
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	M
3rd row	M
4th row	H
5th row	L

Common Values

Value	Count	Frequency (%)
C	250313	25.0%
L	250133	25.0%
H	249861	25.0%
M	249693	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
c	250313	25.0%
l	250133	25.0%
h	249861	25.0%
m	249693	25.0%

Most occurring characters

Value	Count	Frequency (%)
C	250313	25.0%
L	250133	25.0%
H	249861	25.0%
M	249693	25.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	1000000	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	250313	25.0%
L	250133	25.0%
H	249861	25.0%
M	249693	25.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	1000000	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	250313	25.0%
L	250133	25.0%
H	249861	25.0%
M	249693	25.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	1000000	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	250313	25.0%
L	250133	25.0%
H	249861	25.0%
M	249693	25.0%

Order Date
Date

Distinct	2767
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Minimum	2010-01-01 00:00:00
Maximum	2017-12-07 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Order ID
Real number (ℝ)

Distinct	900000
Distinct (%)	90.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4935202 × 10⁸

Minimum	1.0000118 × 10⁸
Maximum	9.9999989 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1.0000118 × 10⁸
5-th percentile	1.4472066 × 10⁸
Q1	3.2396295 × 10⁸
median	5.4865235 × 10⁸
Q3	7.745981 × 10⁸
95-th percentile	9.5535643 × 10⁸
Maximum	9.9999989 × 10⁸
Range	8.9999871 × 10⁸
Interquartile range (IQR)	4.5063515 × 10⁸

Descriptive statistics

Standard deviation	2.599397 × 10⁸
Coefficient of variation (CV)	0.47317511
Kurtosis	-1.2001336
Mean	5.4935202 × 10⁸
Median Absolute Deviation (MAD)	2.252914 × 10⁸
Skewness	0.004494625
Sum	5.4935202 × 10¹⁴
Variance	6.7568648 × 10¹⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
673456180	2	< 0.1%
370419776	2	< 0.1%
847769296	2	< 0.1%
474296367	2	< 0.1%
667237317	2	< 0.1%
214140975	2	< 0.1%
222868669	2	< 0.1%
971594226	2	< 0.1%
558803975	2	< 0.1%
753296744	2	< 0.1%
Other values (899990)	999980	> 99.9%

Value	Count	Frequency (%)
100001180	1	< 0.1%
100002467	1	< 0.1%
100002896	1	< 0.1%
100005042	1	< 0.1%
100007617	1	< 0.1%
100008904	1	< 0.1%
100009763	1	< 0.1%
100010192	1	< 0.1%
100011050	1	< 0.1%
100012767	1	< 0.1%

Value	Count	Frequency (%)
999999892	1	< 0.1%
999999463	1	< 0.1%
999998605	1	< 0.1%
999996888	1	< 0.1%
999996459	1	< 0.1%
999996030	2	< 0.1%
999993884	1	< 0.1%
999992597	1	< 0.1%
999992167	2	< 0.1%
999991738	2	< 0.1%

Ship Date
Date

Distinct	2817
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	7.6 MiB

Minimum	2010-01-01 00:00:00
Maximum	2017-09-17 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

Units Sold
Real number (ℝ)

High correlation

Distinct	10000
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4998.8673

Minimum	1
Maximum	10000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	1
5-th percentile	499
Q1	2502
median	4998
Q3	7496
95-th percentile	9497
Maximum	10000
Range	9999
Interquartile range (IQR)	4994

Descriptive statistics

Standard deviation	2885.3341
Coefficient of variation (CV)	0.57719759
Kurtosis	-1.1990497
Mean	4998.8673
Median Absolute Deviation (MAD)	2497
Skewness	-0.00025107145
Sum	4.9988673 × 10⁹
Variance	8325153.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8959	130	< 0.1%
7228	129	< 0.1%
187	129	< 0.1%
5170	129	< 0.1%
1826	129	< 0.1%
3258	129	< 0.1%
7632	128	< 0.1%
9019	128	< 0.1%
9764	128	< 0.1%
3065	128	< 0.1%
Other values (9990)	998713	99.9%

Value	Count	Frequency (%)
1	101	< 0.1%
2	100	< 0.1%
3	93	< 0.1%
4	104	< 0.1%
5	94	< 0.1%
6	100	< 0.1%
7	114	< 0.1%
8	94	< 0.1%
9	111	< 0.1%
10	97	< 0.1%

Value	Count	Frequency (%)
10000	95	< 0.1%
9999	107	< 0.1%
9998	92	< 0.1%
9997	100	< 0.1%
9996	92	< 0.1%
9995	99	< 0.1%
9994	107	< 0.1%
9993	110	< 0.1%
9992	89	< 0.1%
9991	103	< 0.1%

Unit Price
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	266.02549

Minimum	9.33
Maximum	668.27
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	9.33
5-th percentile	9.33
Q1	81.73
median	154.06
Q3	421.89
95-th percentile	668.27
Maximum	668.27
Range	658.94
Interquartile range (IQR)	340.16

Descriptive statistics

Standard deviation	216.98797
Coefficient of variation (CV)	0.81566607
Kurtosis	-0.80766595
Mean	266.02549
Median Absolute Deviation (MAD)	101.22
Skewness	0.73655188
Sum	2.6602549 × 10⁸
Variance	47083.777
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
9.33	83551	8.4%
81.73	83539	8.4%
152.58	83448	8.3%
437.2	83431	8.3%
255.28	83397	8.3%
47.45	83326	8.3%
668.27	83267	8.3%
109.28	83240	8.3%
651.21	83222	8.3%
205.7	83211	8.3%
Other values (2)	166368	16.6%

Value	Count	Frequency (%)
9.33	83551	8.4%
47.45	83326	8.3%
81.73	83539	8.4%
109.28	83240	8.3%
152.58	83448	8.3%
154.06	83170	8.3%
205.7	83211	8.3%
255.28	83397	8.3%
421.89	83198	8.3%
437.2	83431	8.3%

Value	Count	Frequency (%)
668.27	83267	8.3%
651.21	83222	8.3%
437.2	83431	8.3%
421.89	83198	8.3%
255.28	83397	8.3%
205.7	83211	8.3%
154.06	83170	8.3%
152.58	83448	8.3%
109.28	83240	8.3%
81.73	83539	8.4%

Unit Cost
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	187.52298

Minimum	6.92
Maximum	524.96
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	6.92
5-th percentile	6.92
Q1	35.84
median	97.44
Q3	263.33
95-th percentile	524.96
Maximum	524.96
Range	518.04
Interquartile range (IQR)	227.49

Descriptive statistics

Standard deviation	175.6508
Coefficient of variation (CV)	0.93668947
Kurtosis	-0.68364978
Mean	187.52298
Median Absolute Deviation (MAD)	61.98
Skewness	0.89459132
Sum	1.8752298 × 10⁸
Variance	30853.203
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6.92	83551	8.4%
56.67	83539	8.4%
97.44	83448	8.3%
263.33	83431	8.3%
159.42	83397	8.3%
31.79	83326	8.3%
502.54	83267	8.3%
35.84	83240	8.3%
524.96	83222	8.3%
117.11	83211	8.3%
Other values (2)	166368	16.6%

Value	Count	Frequency (%)
6.92	83551	8.4%
31.79	83326	8.3%
35.84	83240	8.3%
56.67	83539	8.4%
90.93	83170	8.3%
97.44	83448	8.3%
117.11	83211	8.3%
159.42	83397	8.3%
263.33	83431	8.3%
364.69	83198	8.3%

Value	Count	Frequency (%)
524.96	83222	8.3%
502.54	83267	8.3%
364.69	83198	8.3%
263.33	83431	8.3%
159.42	83397	8.3%
117.11	83211	8.3%
97.44	83448	8.3%
90.93	83170	8.3%
56.67	83539	8.4%
35.84	83240	8.3%

Total Revenue
Real number (ℝ)

High correlation

Distinct	119901
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1329562.6

Minimum	9.33
Maximum	6682700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	9.33
5-th percentile	33476.04
Q1	277867.2
median	784444.54
Q3	1822443.9
95-th percentile	4607053.4
Maximum	6682700
Range	6682690.7
Interquartile range (IQR)	1544576.7

Descriptive statistics

Standard deviation	1468527.3
Coefficient of variation (CV)	1.1045191
Kurtosis	1.9386254
Mean	1329562.6
Median Absolute Deviation (MAD)	623339.46
Skewness	1.5797682
Sum	1.3295626 × 10¹²
Variance	2.1565725 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2990356.32	24	< 0.1%
808606.7	23	< 0.1%
152835.1	23	< 0.1%
69844.38	21	< 0.1%
1868972.7	21	< 0.1%
368449.25	21	< 0.1%
1738744.4	20	< 0.1%
1854602.4	20	< 0.1%
414902.8	20	< 0.1%
960207.6	20	< 0.1%
Other values (119891)	999787	> 99.9%

Value	Count	Frequency (%)
9.33	13	< 0.1%
18.66	14	< 0.1%
27.99	9	< 0.1%
37.32	8	< 0.1%
46.65	9	< 0.1%
47.45	10	< 0.1%
55.98	13	< 0.1%
65.31	16	< 0.1%
74.64	5	< 0.1%
81.73	5	< 0.1%

Value	Count	Frequency (%)
6682700	8	< 0.1%
6682031.73	7	< 0.1%
6681363.46	6	< 0.1%
6680695.19	6	< 0.1%
6680026.92	9	< 0.1%
6679358.65	10	< 0.1%
6678690.38	10	< 0.1%
6678022.11	11	< 0.1%
6677353.84	4	< 0.1%
6676685.57	7	< 0.1%

Total Cost
Real number (ℝ)

High correlation

Distinct	119734
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	937267.09

Minimum	6.92
Maximum	5249600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	6.92
5-th percentile	22400
Q1	161728.91
median	466781.76
Q3	1196327.1
95-th percentile	3612249.8
Maximum	5249600
Range	5249593.1
Interquartile range (IQR)	1034598.2

Descriptive statistics

Standard deviation	1148954.3
Coefficient of variation (CV)	1.2258558
Kurtosis	2.4179065
Mean	937267.09
Median Absolute Deviation (MAD)	387535.96
Skewness	1.7495362
Sum	9.3726709 × 10¹¹
Variance	1.3200959 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24801.28	28	< 0.1%
305571.84	27	< 0.1%
98167.52	26	< 0.1%
18600.96	26	< 0.1%
230737.92	26	< 0.1%
243210.24	26	< 0.1%
46556.16	25	< 0.1%
118487.04	25	< 0.1%
456377.67	25	< 0.1%
87306.24	24	< 0.1%
Other values (119724)	999742	> 99.9%

Value	Count	Frequency (%)
6.92	13	< 0.1%
13.84	14	< 0.1%
20.76	9	< 0.1%
27.68	8	< 0.1%
31.79	10	< 0.1%
34.6	9	< 0.1%
35.84	7	< 0.1%
41.52	13	< 0.1%
48.44	16	< 0.1%
55.36	5	< 0.1%

Value	Count	Frequency (%)
5249600	10	< 0.1%
5249075.04	8	< 0.1%
5248550.08	10	< 0.1%
5248025.12	9	< 0.1%
5247500.16	12	< 0.1%
5246975.2	9	< 0.1%
5246450.24	7	< 0.1%
5245925.28	8	< 0.1%
5245400.32	4	< 0.1%
5244875.36	11	< 0.1%

Total Profit
Real number (ℝ)

High correlation

Distinct	119779
Distinct (%)	12.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	392295.56

Minimum	2.41
Maximum	1738700
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.6 MiB

Quantile statistics

Minimum	2.41
5-th percentile	9570.11
Q1	95104.8
median	281054.88
Q3	565307.6
95-th percentile	1217050
Maximum	1738700
Range	1738697.6
Interquartile range (IQR)	470202.8

Descriptive statistics

Standard deviation	378819.9
Coefficient of variation (CV)	0.96564922
Kurtosis	1.2660055
Mean	392295.56
Median Absolute Deviation (MAD)	218301.12
Skewness	1.2949991
Sum	3.9229556 × 10¹¹
Variance	1.4350452 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
66022.56	25	< 0.1%
105019.2	24	< 0.1%
14391.54	23	< 0.1%
433736.64	23	< 0.1%
472439.52	23	< 0.1%
12078.92	23	< 0.1%
86349.24	23	< 0.1%
849223.74	23	< 0.1%
140564.16	22	< 0.1%
48984.48	22	< 0.1%
Other values (119769)	999769	> 99.9%

Value	Count	Frequency (%)
2.41	13	< 0.1%
4.82	14	< 0.1%
7.23	9	< 0.1%
9.64	8	< 0.1%
12.05	9	< 0.1%
14.46	13	< 0.1%
15.66	10	< 0.1%
16.87	16	< 0.1%
19.28	5	< 0.1%
21.69	6	< 0.1%

Value	Count	Frequency (%)
1738700	10	< 0.1%
1738526.13	6	< 0.1%
1738352.26	8	< 0.1%
1738178.39	4	< 0.1%
1738004.52	4	< 0.1%
1737830.65	3	< 0.1%
1737656.78	8	< 0.1%
1737482.91	12	< 0.1%
1737309.04	8	< 0.1%
1737135.17	6	< 0.1%

	Item Type	Order ID	Order Priority	Region	Sales Channel	Total Cost	Total Profit	Total Revenue	Unit Cost	Unit Price	Units Sold
Item Type	1.000	0.000	0.000	0.000	0.000	0.355	0.322	0.334	1.000	1.000	0.000
Order ID	0.000	1.000	0.000	0.000	0.000	-0.000	-0.000	-0.000	-0.000	-0.000	-0.000
Order Priority	0.000	0.000	1.000	0.000	0.001	0.001	0.000	0.000	0.000	0.000	0.000
Region	0.000	0.000	0.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.001
Sales Channel	0.000	0.000	0.001	0.000	1.000	0.001	0.002	0.003	0.000	0.000	0.000
Total Cost	0.355	-0.000	0.001	0.000	0.001	1.000	0.884	0.988	0.793	0.778	0.536
Total Profit	0.322	-0.000	0.000	0.000	0.002	0.884	1.000	0.940	0.600	0.655	0.621
Total Revenue	0.334	-0.000	0.000	0.000	0.003	0.988	0.940	1.000	0.752	0.759	0.573
Unit Cost	1.000	-0.000	0.000	0.000	0.000	0.793	0.600	0.752	1.000	0.972	-0.001
Unit Price	1.000	-0.000	0.000	0.000	0.000	0.778	0.655	0.759	0.972	1.000	-0.001
Units Sold	0.000	-0.000	0.000	0.001	0.000	0.536	0.621	0.573	-0.001	-0.001	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Region	Country	Item Type	Sales Channel	Order Priority	Order Date	Order ID	Ship Date	Units Sold	Unit Price	Unit Cost	Total Revenue	Total Cost	Total Profit
0	Sub-Saharan Africa	South Africa	Fruits	Offline	M	27-07-2012	443368995	7/28/2012	1593	9.33	6.92	14862.69	11023.56	3839.13
1	Middle East and North Africa	Morocco	Clothes	Online	M	14-09-2013	667593514	10/19/2013	4611	109.28	35.84	503890.08	165258.24	338631.84
2	Australia and Oceania	Papua New Guinea	Meat	Offline	M	15-05-2015	940995585	06-04-2015	360	421.89	364.69	151880.40	131288.40	20592.00
3	Sub-Saharan Africa	Djibouti	Clothes	Offline	H	17-05-2017	880811536	07-02-2017	562	109.28	35.84	61415.36	20142.08	41273.28
4	Europe	Slovakia	Beverages	Offline	L	26-10-2016	174590194	12-04-2016	3973	47.45	31.79	188518.85	126301.67	62217.18
5	Asia	Sri Lanka	Fruits	Online	L	07-11-2011	830192887	12/18/2011	1379	9.33	6.92	12866.07	9542.68	3323.39
6	Sub-Saharan Africa	Seychelles	Beverages	Online	M	18-01-2013	425793445	2/16/2013	597	47.45	31.79	28327.65	18978.63	9349.02
7	Sub-Saharan Africa	Tanzania	Beverages	Online	L	30-11-2016	659878194	1/16/2017	1476	47.45	31.79	70036.20	46922.04	23114.16
8	Sub-Saharan Africa	Ghana	Office Supplies	Online	L	23-03-2017	601245963	4/15/2017	896	651.21	524.96	583484.16	470364.16	113120.00
9	Sub-Saharan Africa	Tanzania	Cosmetics	Offline	L	23-05-2016	739008080	5/24/2016	7768	437.20	263.33	3396169.60	2045547.44	1350622.16

	Region	Country	Item Type	Sales Channel	Order Priority	Order Date	Order ID	Ship Date	Units Sold	Unit Price	Unit Cost	Total Revenue	Total Cost	Total Profit
999990	Sub-Saharan Africa	Zimbabwe	Meat	Online	C	23-02-2010	497280108	3/23/2010	5090	421.89	364.69	2147420.10	1856272.10	291148.00
999991	Europe	Netherlands	Fruits	Offline	C	28-08-2014	277629506	09-05-2014	5595	9.33	6.92	52201.35	38717.40	13483.95
999992	Middle East and North Africa	Iran	Personal Care	Online	H	27-08-2013	461355674	9/28/2013	4251	81.73	56.67	347434.23	240904.17	106530.06
999993	Europe	Armenia	Personal Care	Offline	C	28-03-2015	412569940	4/26/2015	7468	81.73	56.67	610359.64	423211.56	187148.08
999994	Europe	Germany	Office Supplies	Online	C	16-03-2017	465696132	04-04-2017	8689	651.21	524.96	5658363.69	4561377.44	1096986.25
999995	Sub-Saharan Africa	Senegal	Baby Food	Offline	L	06-11-2010	575470578	12-11-2010	3387	255.28	159.42	864633.36	539955.54	324677.82
999996	Central America and the Caribbean	Panama	Office Supplies	Offline	C	12-01-2015	766942107	03-01-2015	4068	651.21	524.96	2649122.28	2135537.28	513585.00
999997	Europe	Norway	Office Supplies	Online	M	25-10-2011	685472047	12-05-2011	5266	651.21	524.96	3429271.86	2764439.36	664832.50
999998	Europe	Montenegro	Beverages	Offline	M	31-10-2010	946734225	12-08-2010	8551	47.45	31.79	405744.95	271836.29	133908.66
999999	Central America and the Caribbean	Nicaragua	Meat	Online	C	17-03-2015	886714971	04-08-2015	7519	421.89	364.69	3172190.91	2742104.11	430086.80

Most frequently occurring

	Region	Country	Item Type	Sales Channel	Order Priority	Order Date	Order ID	Ship Date	Units Sold	Unit Price	Unit Cost	Total Revenue	Total Cost	Total Profit	# duplicates
0	Asia	Bangladesh	Baby Food	Offline	H	12-05-2011	831867444	5/31/2011	6917	255.28	159.42	1765771.76	1102708.14	663063.62	2
1	Asia	Bangladesh	Baby Food	Offline	H	20-03-2010	411088502	4/17/2010	9078	255.28	159.42	2317431.84	1447214.76	870217.08	2
2	Asia	Bangladesh	Baby Food	Offline	H	23-04-2011	779794824	06-02-2011	7472	255.28	159.42	1907452.16	1191186.24	716265.92	2
3	Asia	Bangladesh	Baby Food	Offline	L	22-06-2014	597013223	07-04-2014	8334	255.28	159.42	2127503.52	1328606.28	798897.24	2
4	Asia	Bangladesh	Baby Food	Offline	L	24-11-2011	122104299	12/18/2011	2230	255.28	159.42	569274.40	355506.60	213767.80	2
5	Asia	Bangladesh	Baby Food	Offline	M	05-02-2014	847749555	02-06-2014	6787	255.28	159.42	1732585.36	1081983.54	650601.82	2
6	Asia	Bangladesh	Baby Food	Offline	M	12-04-2015	432368505	05-02-2015	6304	255.28	159.42	1609285.12	1004983.68	604301.44	2
7	Asia	Bangladesh	Baby Food	Offline	M	16-03-2014	951894795	3/26/2014	5678	255.28	159.42	1449479.84	905186.76	544293.08	2
8	Asia	Bangladesh	Baby Food	Offline	M	30-03-2015	368528497	05-12-2015	4627	255.28	159.42	1181180.56	737636.34	443544.22	2
9	Asia	Bangladesh	Baby Food	Online	C	03-04-2012	695760571	4/14/2012	9869	255.28	159.42	2519358.32	1573315.98	946042.34	2

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring